{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["DATA","ST","SC","GEN","MDM VI To VIII","MDM IX To X","MDM VI to X","Register VI to VIII & IX To X","register"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DATA","index":0,"n_rows":144,"n_cols":23,"rows_kept":144,"cut":false,"hidden":false,"merged":[[17,19,18,20],[3,16,4,17],[15,16,16,17],[17,16,18,17],[15,18,16,18],[17,18,18,18],[19,16,20,17],[19,18,20,18],[20,2,20,4],[64,3,64,4],[1,1,1,22],[38,6,38,14],[12,16,12,18],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[14,2,14,4],[10,2,10,4],[11,2,11,4],[15,2,15,4],[17,2,17,4],[17,22,18,23],[19,22,20,23],[18,2,18,4],[13,22,14,23],[15,22,16,23],[12,1,13,1],[3,10,19,10],[3,7,3,9],[3,12,3,14],[15,19,16,20],[19,2,19,4],[19,19,20,20],[13,19,14,20],[3,1,3,4],[20,6,20,14],[13,21,14,21],[15,21,16,21],[17,21,18,21]]}
[]
[null,"MID DAY MEALS SOFTWARE"]
[]
[null,"Mid day Meal Programme",null,null,null,null,"Day","VI TO VIII",null,null,null,"Day","IX TO X",null,null,null,"Full version release shortly"]
[null,"Starting date of Month",null,null,null,null,1,125,17,2,null,1,254,17,254]
[null,"Mandal",{"$f":"G98","v":"Balayapalli"},null,null,null,2,125,18,2,null,2,1,18,2]
[null,"Habitation","Balayapalli",null,null,null,3,125,19,2,null,3,1,19,2]
[null,"School Name","ZPPHS,Balayapalli",null,null,null,4,125,20,2,null,4,1,20,2]
[null,"Total students",242,138,{"$f":"C9+D9","v":380},null,5,125,21,2,null,5,1,21,2]
[null,"Hostel Students",51,22,{"$f":"C10+D10","v":73},null,6,125,22,2,null,6,1,22,2]
[null,"IA Name & Address","B.Polamma",null,null,null,7,125,23,2,null,7,1,23,2]
[null,"Opening Balance",1330.5,null,null,null,8,125,24,2,null,8,1,24,2]
[null,"Rice received during Month",1500,"Date",5,null,9,125,25,2,null,9,1,25,2,null,"G.S.REDDY"]
[null,null,1500,"Date",5,null,10,125,26,2,null,10,1,26,2,null,null,null,null,"Utalised\nRice",null,"Balance\nRice","Bill amount"]
[null,"Meals cost for Head",null,null,null,null,11,125,27,2,null,11,1,27,2]
[null,"Balance Rice",{"$f":"C12+C13-(J20+O20)*0.15","v":2829.9},null,null,null,12,125,28,2,null,12,1,28,2,null,"MDM VI To VIII",null,{"$f":"'MDM VI To VIII'!F45","v":2159},{"$f":"'MDM VI To VIII'!F45*0.15","v":323.84999999999997},null,{"$f":"C12+C13-T16","v":2506.65},{"$f":"'MDM VI To VIII'!H45","v":"Rs.0"}]
[null,null,null,null,null,null,13,125,29,2,null,13,1,29,2]
[null,"School Code",960061,null,null,null,14,125,30,2,null,14,1,30,2,null,"MDM IX To X",null,{"$f":"'MDM IX To X'!E44","v":551},{"$f":"'MDM IX To X'!E44*0.15","v":82.649999999999991},null,{"$f":"V16-T18","v":2424},{"$f":"'MDM IX To X'!G44","v":"Rs.0"}]
[null,null,null,null,null,null,15,125,31,2,null,15,1,31,2]
[null,null,null,null,null,null,16,254,null,2,null,16,1,null,2,null,"MDM VI To X",null,{"$f":"S16+S18","v":2710},{"$f":"'MDM VI to X'!I44*0.15","v":406.5},null,{"$f":"'MDM VI to X'!L44*0.15","v":0},{"$f":"\"Rs.\"&S16*C15+S18*C15","v":"Rs.0"}]
[]
[null,null,null,null,null,null,"S.No","VI TO VII",null,"VI TO VII",null,"S.No","VIII TO X",null,"VIII TO X"]
[null,null,null,null,null,null,1,{"$f":"IF(H5>0,6,0)","v":6},null,6,null,1,{"$f":"IF(M5>0,8,0)","v":8},null,8]
[null,null,null,null,null,null,2,6,null,6,null,2,8,null,8]
[null,null,null,null,null,null,3,6,null,6,null,3,8,null,8]
[null,null,null,null,null,null,4,6,null,6,null,4,8,null,8]
[null,null,null,null,null,null,5,6,null,6,null,5,8,null,8]
[null,null,null,null,null,null,6,6,null,6,null,6,8,null,8]
[null,null,null,null,null,null,7,6,null,6,null,7,8,null,8]
[null,null,null,null,null,null,8,6,null,6,null,8,8,null,8]
[null,null,null,null,null,null,9,6,null,6,null,9,8,null,8]
[null,null,null,null,null,null,10,6,null,6,null,10,8,null,8]
[null,null,null,null,null,null,11,6,null,6,null,11,8,null,8]
[null,null,null,null,null,5,12,6,null,6,null,12,8,null,8]
[null,null,null,null,null,null,13,6,null,6,null,13,8,null,8]
[null,null,null,null,null,null,14,6,null,6,null,14,8,null,8]
[null,null,null,null,null,null,15,6,null,6,null,15,8,null,8]
[null,null,null,null,null,null,16,6,null,{"$f":"SUM(J23:J37)+SUM(H23:H38)","v":186},null,16,8,null,{"$f":"SUM(O23:O37)+SUM(M23:M38)","v":248}]
[null,null,null,null,null,null,"SC"]
[null,null,null,null,null,null,"S.No","VI TO VII",null,"VI TO VII",null,"S.No","VIII TO \nX",null,"VIII TO \nX"]
[null,null,null,null,null,null,1,{"$f":"IF(H5>0,49,0)","v":49},null,49,null,1,{"$f":"IF(M5>0,75,0)","v":75},null,75]
[null,null,null,null,null,null,2,49,null,49,null,2,75,null,75]
[null,null,null,null,null,null,3,49,null,49,null,3,75,null,75]
[null,null,null,null,null,null,4,49,null,49,null,4,75,null,75]
[null,null,null,null,null,null,5,49,null,49,null,5,75,null,75]
[null,null,null,null,null,null,6,49,null,49,null,6,75,null,75]
[null,null,null,null,null,null,7,49,null,49,null,7,75,null,75]
[null,null,null,null,null,null,8,49,null,49,null,8,75,null,75]
[null,null,null,null,null,null,9,49,null,49,null,9,75,null,75]
[null,null,null,null,null,null,10,49,null,49,null,10,75,null,75]
[null,null,null,null,null,null,11,49,null,49,null,11,75,null,75]
[null,null,null,null,null,null,12,49,null,49,null,12,75,null,75]
[null,null,null,null,null,null,13,49,null,49,null,13,75,null,75]
[null,null,null,null,null,null,14,49,null,49,null,14,75,null,75]
[null,null,null,null,null,null,15,49,null,49,null,15,75,null,75]
[null,null,null,null,null,null,16,49,null,{"$f":"SUM(J41:J55)+SUM(H41:H56)","v":1519},null,16,75,null,{"$f":"SUM(O41:O55)+SUM(M41:M56)","v":2325}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Days Of Month"]
[null,null,null,1,1]
[null,null,null,2,2]
[null,null,null,3,3]
[null,null,null,4,4]
[null,null,null,5,5]
[null,null,null,6,6]
[null,null,null,7,7]
[null,null,null,8,8]
[null,null,null,9,9]
[null,null,null,10,10]
[null,null,null,11,11]
[null,null,null,12,12]
[null,null,null,13,13]
[null,null,null,14,14]
[null,null,null,15,15]
[null,null,null,16,16]
[null,null,null,17,17]
[null,null,null,18,18]
[null,null,null,19,19]
[null,null,null,20,20]
[null,null,null,21,21]
[null,null,null,22,22]
[null,null,null,23,23]
[null,null,null,24,24]
[null,null,null,25,25]
[null,null,null,26,26]
[null,null,null,27,27]
[null,null,null,28,28]
[null,null,null,29,29]
[null,null,null,30,30]
[null,null,null,31,31]
[null,null,10,{"$f":"LOOKUP(C97,C99:C110,D99:D110)","v":"October"},1,{"$f":"LOOKUP(E97,C99:C110,E99:E110)","v":2010},{"$f":"D97&\"-\"&F97","v":"October-2010"},null,null,{"$f":"DATE(F97,C97,1)","v":"2010-10-01"},null,null,{"$f":"D97&\" \"&F97","v":"October 2010"}]
[null,null,null,null,null,5,{"$f":"LOOKUP(F98,F99:F144,G99:G144)","v":"Balayapalli"}]
[null,null,1,"January",2010,1,"Allur",null,null,2,null,{"$f":"LOOKUP(J99,J100:J101,L100:L101)","v":4.17}]
[null,null,2,"February",2011,2,"Ananthasagaram",null,null,1,null,3.96]
[null,null,3,"March",2012,3,"Anumasamudrampeta",null,null,2,null,4.17]
[null,null,4,"April",2013,4,"Atmakur"]
[null,null,5,"May",2014,5,"Balayapalli"]
[null,null,6,"June",2015,6,"Bogole"]
[null,null,7,"July",2016,7,"Buchireddipalem"]
[null,null,8,"August",2017,8,"Chejerla "]
[null,null,9,"September",2018,9,"Chillakur "]
[null,null,10,"October",2019,10,"Chittamur "]
[null,null,11,"November",2020,11,"Dagadarthi "]
[null,null,12,"December",2021,12,"Dakkili"]
[null,null,null,null,null,13,"Doravarisatram"]
[null,null,null,null,null,14,"Duttalur "]
[null,null,null,null,null,15,"Gudur "]
[null,null,null,null,null,16,"Indukurpet "]
[null,null,null,null,null,17,"Jaladanki "]
[null,null,null,null,null,18,"Kaligiri "]
[null,null,null,null,null,19,"Kaluvoya "]
[null,null,null,null,null,20,"Kavali "]
[null,null,null,null,null,21,"Kodavalur "]
[null,null,null,null,null,22,"Kondapuram"]
[null,null,null,null,null,23,"Kota"]
[null,null,null,null,null,24,"Kovur"]
[null,null,null,null,null,25,"Manubolu"]
[null,null,null,null,null,26,"Marripadu"]
[null,null,null,null,null,27,"Muthukur"]
[null,null,null,null,null,28,"Naidupeta"]
[null,null,null,null,null,29,"Nellore"]
[null,null,null,null,null,30,"Ojili"]
[null,null,null,null,null,31,"Pellakur"]
[null,null,null,null,null,32,"Podlakur"]
[null,null,null,null,null,33,"Rapur "]
[null,null,null,null,null,34,"Sangam"]
[null,null,null,null,null,35,"Seetharamapuram"]
[null,null,null,null,null,36,"Sullurpeta"]
[null,null,null,null,null,37,"Sydapuram "]
[null,null,null,null,null,38,"Tada "]
[null,null,null,null,null,39,"Thotapalligudur "]
[null,null,null,null,null,40,"Udayagiri "]
[null,null,null,null,null,41,"Vakadu "]
[null,null,null,null,null,42,"Varikuntapadu "]
[null,null,null,null,null,43,"Venkatachalam "]
[null,null,null,null,null,44,"Venkatagiri "]
[null,null,null,null,null,45,"Vidavalur "]
[null,null,null,null,null,46,"Vinjamur"]

{"sheet":"ST","index":1,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":true,"merged":[[0,11,51,11],[1,0,51,0],[44,1,44,10],[45,1,45,10],[48,1,48,3],[48,7,48,10],[43,1,43,2],[7,1,7,10],[1,1,1,10],[2,1,2,2],[10,1,11,1],[10,2,11,2],[10,9,11,9],[10,10,11,10],[10,3,10,5],[10,6,10,8],[51,7,51,10],[0,0,0,10]]}
[]
[null,"DAY-WISE DETAILED VOUCHER FOR SERVING MID-DAY MEAL PROGRAMME FOR THE MONTH OF"]
[null,{"$f":"DATA!C5","v":"00:00:00"},null,null,null,null,"(To be prepared by IA/HM and submit toMPDO)"]
[]
[null,{"$f":"CONCATENATE(\"Name of the Mandal:\",DATA!C6)","v":"Name of the Mandal:Balayapalli"},null,null,null,null,{"$f":"CONCATENATE(\"School Name & Place:\",DATA!C8)","v":"School Name & Place:ZPPHS,Balayapalli"}]
[null,{"$f":"CONCATENATE(\"Name of the Habitation:\",DATA!C7)","v":"Name of the Habitation:Balayapalli"},null,null,null,null,"MDM School Code:"]
[]
[null,{"$f":"CONCATENATE(\"Regular students:\",DATA!E9-DATA!E10,\"                                    \",\"Hostel Students:\",DATA!E10,\"                                    \",\"Total Roll:\",DATA!E9-DATA!E10+DATA!E10)","v":"Regular students:307                                    Hostel Students:73                                    Total Roll:380"}]
[null,{"$f":"CONCATENATE(\"IA Name & Address:\",DATA!C11)","v":"IA Name & Address:B.Polamma"}]
[]
[null,"DATE","DAY","ST Children attended \nto School",null,null,"ST No. of Children \nFed",null,null,"Cost for \nchild","Total \namount"]
[null,null,null,"VI \nTO \nVII","VIII \nTO \nX","Total","VI \nTO \nVII","VIII \nTO \nX","Total"]
[null,{"$f":"DATA!C5","v":"00:00:00"},{"$f":"B13","v":"00:00:00"},{"$f":"DATA!H23","v":6},{"$f":"DATA!M23","v":8},{"$f":"IF(D13=0,0,D13+E13)","v":14},{"$f":"IF(C13=\"Sunday\",\" \",D13)","v":6},{"$f":"IF(D13=\"Sunday\",\" \",E13)","v":8},{"$f":"IF(G13=0,0,G13+H13)","v":14},{"$f":"IF(I13=0,\" \",DATA!C15)","v":0},{"$f":"IF(I13=0,\" \",I13*J13)","v":0}]
[null,{"$f":"B13+1","v":"1900-01-01"},"1900-01-01",{"$f":"DATA!H24","v":6},{"$f":"DATA!M24","v":8},14,6,8,14,{"$f":"IF(I14=0,\" \",DATA!C15)","v":0},{"$f":"IF(I14=0,\" \",I14*J14)","v":0}]
[null,"1900-01-02","1900-01-02",{"$f":"DATA!H25","v":6},{"$f":"DATA!M25","v":8},14,6,8,14,{"$f":"IF(I15=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-03","1900-01-03",{"$f":"DATA!H26","v":6},{"$f":"DATA!M26","v":8},14,6,8,14,{"$f":"IF(I16=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-04","1900-01-04",{"$f":"DATA!H27","v":6},{"$f":"DATA!M27","v":8},14,6,8,14,{"$f":"IF(I17=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-05","1900-01-05",{"$f":"DATA!H28","v":6},{"$f":"DATA!M28","v":8},14,6,8,14,{"$f":"IF(I18=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-06","1900-01-06",{"$f":"DATA!H29","v":6},{"$f":"DATA!M29","v":8},14,6,8,14,{"$f":"IF(I19=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-07","1900-01-07",{"$f":"DATA!H30","v":6},{"$f":"DATA!M30","v":8},14,6,8,14,{"$f":"IF(I20=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-08","1900-01-08",{"$f":"DATA!H31","v":6},{"$f":"DATA!M31","v":8},14,6,8,14,{"$f":"IF(I21=0,\" \",DATA!C15)","v":0},{"$f":"IF(I21=0,\" \",I21*J21)","v":0}]
[null,"1900-01-09","1900-01-09",{"$f":"DATA!H32","v":6},{"$f":"DATA!M32","v":8},14,6,8,14,{"$f":"IF(I22=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-10","1900-01-10",{"$f":"DATA!H33","v":6},{"$f":"DATA!M33","v":8},14,6,8,14,{"$f":"IF(I23=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-11","1900-01-11",{"$f":"DATA!H34","v":6},{"$f":"DATA!M34","v":8},14,6,8,14,{"$f":"IF(I24=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-12","1900-01-12",{"$f":"DATA!H35","v":6},{"$f":"DATA!M35","v":8},14,6,8,14,{"$f":"IF(I25=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-13","1900-01-13",{"$f":"DATA!H36","v":6},{"$f":"DATA!M36","v":8},14,6,8,14,{"$f":"IF(I26=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-14","1900-01-14",{"$f":"DATA!H37","v":6},{"$f":"DATA!M37","v":8},14,6,8,14,{"$f":"IF(I27=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-15","1900-01-15",{"$f":"DATA!H38","v":6},{"$f":"DATA!M38","v":8},14,6,8,14,{"$f":"IF(I28=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-16","1900-01-16",{"$f":"DATA!J23","v":6},{"$f":"DATA!O23","v":8},14,6,8,14,{"$f":"IF(I29=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-17","1900-01-17",{"$f":"DATA!J24","v":6},{"$f":"DATA!O24","v":8},14,6,8,14,{"$f":"IF(I30=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-18","1900-01-18",{"$f":"DATA!J25","v":6},{"$f":"DATA!O25","v":8},14,6,8,14,{"$f":"IF(I31=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-19","1900-01-19",{"$f":"DATA!J26","v":6},{"$f":"DATA!O26","v":8},14,6,8,14,{"$f":"IF(I32=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-20","1900-01-20",{"$f":"DATA!J27","v":6},{"$f":"DATA!O27","v":8},14,6,8,14,{"$f":"IF(I33=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-21","1900-01-21",{"$f":"DATA!J28","v":6},{"$f":"DATA!O28","v":8},14,6,8,14,{"$f":"IF(I34=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-22","1900-01-22",{"$f":"DATA!J29","v":6},{"$f":"DATA!O29","v":8},14,6,8,14,{"$f":"IF(I35=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-23","1900-01-23",{"$f":"DATA!J30","v":6},{"$f":"DATA!O30","v":8},14,6,8,14,{"$f":"IF(I36=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-24","1900-01-24",{"$f":"DATA!J31","v":6},{"$f":"DATA!O31","v":8},14,6,8,14,{"$f":"IF(I37=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-25","1900-01-25",{"$f":"DATA!J32","v":6},{"$f":"DATA!O32","v":8},14,6,8,14,{"$f":"IF(I38=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-26","1900-01-26",{"$f":"DATA!J33","v":6},{"$f":"DATA!O33","v":8},14,6,8,14,{"$f":"IF(I39=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-27","1900-01-27",{"$f":"DATA!J34","v":6},{"$f":"DATA!O34","v":8},14,6,8,14,{"$f":"IF(I40=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-28","1900-01-28",{"$f":"DATA!J35","v":6},{"$f":"DATA!O35","v":8},14,6,8,14,{"$f":"IF(I41=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-29","1900-01-29",{"$f":"DATA!J36","v":6},{"$f":"DATA!O36","v":8},14,6,8,14,{"$f":"IF(I42=0,\" \",DATA!C15)","v":0},0]
[null,{"$f":"IF(DATA!J19>0,B42+1,0)","v":"1900-01-30"},"1900-01-30",{"$f":"DATA!J37","v":6},{"$f":"DATA!O37","v":8},14,6,8,14,{"$f":"IF(I43=0,\" \",DATA!C15)","v":0},0]
[null,"Total",null,{"$f":"SUM(D13:D43)","v":186},248,434,186,248,434,"Total",{"$f":"SUM(K13:K43)","v":0},null,null,{"$f":"K44+SC!K44+GEN!K44","v":0}]
[null,"Rice Particulars in KG's"]
[null,{"$f":"CONCATENATE(\"Opening Balance:\",DATA!C12,\"          \",\"Rice received during Month:\",DATA!C13,\"        \",\"Total rice:\",DATA!C12+DATA!C13,\"         \",\"Utalised:\",I44*0.15,\"           \",\"Balance:\",DATA!C12+DATA!C13-I44*0.15)","v":"Opening Balance:1330.5          Rice received during Month:1500        Total rice:2830.5         Utalised:65.1           Balance:2765.4"}]
[]
[]
[null,"Signature of the Chair person\n/Chairman of the Governing Body of the Aided School",null,null,null,null,null,"Signature of the authorised person \nof the Implementing Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATA!C12+DATA!C13-I44*0.15","v":2765.4}]
[]
[null,null,null,null,null,null,null,"Signature of the Head Master"]

{"sheet":"SC","index":2,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":true,"merged":[[51,7,51,10],[0,0,0,10],[0,11,51,11],[1,0,51,0],[44,1,44,10],[45,1,45,10],[48,1,48,3],[48,7,48,10],[43,1,43,2],[7,1,7,10],[1,1,1,10],[2,1,2,2],[10,1,11,1],[10,2,11,2],[10,9,11,9],[10,10,11,10],[10,3,10,5],[10,6,10,8]]}
[]
[null,"DAY-WISE DETAILED VOUCHER FOR SERVING MID-DAY MEAL PROGRAMME FOR THE MONTH OF"]
[null,{"$f":"DATA!C5","v":"00:00:00"},null,null,null,null,"(To be prepared by IA/HM and submit toMPDO)"]
[]
[null,{"$f":"CONCATENATE(\"Name of the Mandal:\",DATA!C6)","v":"Name of the Mandal:Balayapalli"},null,null,null,null,{"$f":"CONCATENATE(\"School Name & Place:\",DATA!C8)","v":"School Name & Place:ZPPHS,Balayapalli"}]
[null,{"$f":"CONCATENATE(\"Name of the Habitation:\",DATA!C7)","v":"Name of the Habitation:Balayapalli"},null,null,null,null,"MDM School Code:"]
[]
[null,{"$f":"CONCATENATE(\"Regular students:\",DATA!E9-DATA!E10,\"                                    \",\"Hostel Students:\",DATA!E10,\"                                    \",\"Total Roll:\",DATA!E9-DATA!E10+DATA!E10)","v":"Regular students:307                                    Hostel Students:73                                    Total Roll:380"}]
[null,{"$f":"CONCATENATE(\"IA Name & Address:\",DATA!C11)","v":"IA Name & Address:B.Polamma"}]
[]
[null,"DATE","DAY","SC Children attended \nto School",null,null,"SC No. of Children \nFed",null,null,"Cost for \nchild","Total \namount"]
[null,null,null,"VI \nTO \nVII","VIII \nTO \nX","Total","VI \nTO \nVII","VIII \nTO \nX","Total"]
[null,{"$f":"DATA!C5","v":"00:00:00"},{"$f":"B13","v":"00:00:00"},{"$f":"DATA!H41","v":49},{"$f":"DATA!M41","v":75},{"$f":"IF(D13=0,0,D13+E13)","v":124},{"$f":"IF(C13=\"Sunday\",\" \",D13)","v":49},{"$f":"IF(D13=\"Sunday\",\" \",E13)","v":75},{"$f":"IF(G13=0,0,G13+H13)","v":124},{"$f":"IF(I13=0,\" \",DATA!C15)","v":0},{"$f":"IF(I13=0,\" \",I13*J13)","v":0}]
[null,{"$f":"B13+1","v":"1900-01-01"},"1900-01-01",{"$f":"DATA!H42","v":49},{"$f":"DATA!M42","v":75},124,49,75,124,{"$f":"IF(I14=0,\" \",DATA!C15)","v":0},{"$f":"IF(I14=0,\" \",I14*J14)","v":0}]
[null,"1900-01-02","1900-01-02",{"$f":"DATA!H43","v":49},{"$f":"DATA!M43","v":75},124,49,75,124,{"$f":"IF(I15=0,\" \",DATA!C15)","v":0},{"$f":"IF(I15=0,\" \",I15*J15)","v":0}]
[null,"1900-01-03","1900-01-03",{"$f":"DATA!H44","v":49},{"$f":"DATA!M44","v":75},124,49,75,124,{"$f":"IF(I16=0,\" \",DATA!C15)","v":0},{"$f":"IF(I16=0,\" \",I16*J16)","v":0}]
[null,"1900-01-04","1900-01-04",{"$f":"DATA!H45","v":49},{"$f":"DATA!M45","v":75},124,49,75,124,{"$f":"IF(I17=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-05","1900-01-05",{"$f":"DATA!H46","v":49},{"$f":"DATA!M46","v":75},124,49,75,124,{"$f":"IF(I18=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-06","1900-01-06",{"$f":"DATA!H47","v":49},{"$f":"DATA!M47","v":75},124,49,75,124,{"$f":"IF(I19=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-07","1900-01-07",{"$f":"DATA!H48","v":49},{"$f":"DATA!M48","v":75},124,49,75,124,{"$f":"IF(I20=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-08","1900-01-08",{"$f":"DATA!H49","v":49},{"$f":"DATA!M49","v":75},124,49,75,124,{"$f":"IF(I21=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-09","1900-01-09",{"$f":"DATA!H50","v":49},{"$f":"DATA!M50","v":75},124,49,75,124,{"$f":"IF(I22=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-10","1900-01-10",{"$f":"DATA!H51","v":49},{"$f":"DATA!M51","v":75},124,49,75,124,{"$f":"IF(I23=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-11","1900-01-11",{"$f":"DATA!H52","v":49},{"$f":"DATA!M52","v":75},124,49,75,124,{"$f":"IF(I24=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-12","1900-01-12",{"$f":"DATA!H53","v":49},{"$f":"DATA!M53","v":75},124,49,75,124,{"$f":"IF(I25=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-13","1900-01-13",{"$f":"DATA!H54","v":49},{"$f":"DATA!M54","v":75},124,49,75,124,{"$f":"IF(I26=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-14","1900-01-14",{"$f":"DATA!H55","v":49},{"$f":"DATA!M55","v":75},124,49,75,124,{"$f":"IF(I27=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-15","1900-01-15",{"$f":"DATA!H56","v":49},{"$f":"DATA!M56","v":75},124,49,75,124,{"$f":"IF(I28=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-16","1900-01-16",{"$f":"DATA!J41","v":49},{"$f":"DATA!O41","v":75},124,49,75,124,{"$f":"IF(I29=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-17","1900-01-17",{"$f":"DATA!J42","v":49},{"$f":"DATA!O42","v":75},124,49,75,124,{"$f":"IF(I30=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-18","1900-01-18",{"$f":"DATA!J43","v":49},{"$f":"DATA!O43","v":75},124,49,75,124,{"$f":"IF(I31=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-19","1900-01-19",{"$f":"DATA!J44","v":49},{"$f":"DATA!O44","v":75},124,49,75,124,{"$f":"IF(I32=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-20","1900-01-20",{"$f":"DATA!J45","v":49},{"$f":"DATA!O45","v":75},124,49,75,124,{"$f":"IF(I33=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-21","1900-01-21",{"$f":"DATA!J46","v":49},{"$f":"DATA!O46","v":75},124,49,75,124,{"$f":"IF(I34=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-22","1900-01-22",{"$f":"DATA!J47","v":49},{"$f":"DATA!O47","v":75},124,49,75,124,{"$f":"IF(I35=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-23","1900-01-23",{"$f":"DATA!J48","v":49},{"$f":"DATA!O48","v":75},124,49,75,124,{"$f":"IF(I36=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-24","1900-01-24",{"$f":"DATA!J49","v":49},{"$f":"DATA!O49","v":75},124,49,75,124,{"$f":"IF(I37=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-25","1900-01-25",{"$f":"DATA!J50","v":49},{"$f":"DATA!O50","v":75},124,49,75,124,{"$f":"IF(I38=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-26","1900-01-26",{"$f":"DATA!J51","v":49},{"$f":"DATA!O51","v":75},124,49,75,124,{"$f":"IF(I39=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-27","1900-01-27",{"$f":"DATA!J52","v":49},{"$f":"DATA!O52","v":75},124,49,75,124,{"$f":"IF(I40=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-28","1900-01-28",{"$f":"DATA!J53","v":49},{"$f":"DATA!O53","v":75},124,49,75,124,{"$f":"IF(I41=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-29","1900-01-29",{"$f":"DATA!J54","v":49},{"$f":"DATA!O54","v":75},124,49,75,124,{"$f":"IF(I42=0,\" \",DATA!C15)","v":0},0]
[null,{"$f":"IF(DATA!J19>0,B42+1,0)","v":"1900-01-30"},"1900-01-30",{"$f":"DATA!J55","v":49},{"$f":"DATA!O55","v":75},124,49,75,124,{"$f":"IF(I43=0,\" \",DATA!C15)","v":0},0]
[null,"Total",null,{"$f":"SUM(D13:D43)","v":1519},2325,3844,1519,2325,3844,"Total",{"$f":"SUM(K13:K43)","v":0},null,null,{"$f":"K44+ST!K44+GEN!K44","v":0}]
[null,"Rice Particulars in KG's"]
[null,{"$f":"CONCATENATE(\"Opening Balance:\",ST!N50,\"          \",\"Rice received during Month:\",0,\"        \",\"Total rice:\",ST!N50,\"         \",\"Utalised:\",I44*0.15,\"           \",\"Balance:\",ST!N50-I44*0.15)","v":"Opening Balance:2765.4          Rice received during Month:0        Total rice:2765.4         Utalised:576.6           Balance:2188.8"}]
[]
[]
[null,"Signature of the Chair person\n/Chairman of the Governing Body of the Aided School",null,null,null,null,null,"Signature of the authorised person \nof the Implementing Agency",null,null,null,null,null,{"$f":"ST!N50-I44*0.15","v":2188.8000000000002}]
[]
[]
[null,null,null,null,null,null,null,"Signature of the Head Master"]

{"sheet":"GEN","index":3,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":true,"merged":[[0,11,51,11],[1,0,51,0],[44,1,44,10],[45,1,45,10],[48,1,48,3],[48,7,48,10],[43,1,43,2],[7,1,7,10],[1,1,1,10],[2,1,2,2],[10,1,11,1],[10,2,11,2],[10,9,11,9],[10,10,11,10],[10,3,10,5],[10,6,10,8],[51,7,51,10],[0,0,0,10]]}
[]
[null,"DAY-WISE DETAILED VOUCHER FOR SERVING MID-DAY MEAL PROGRAMME FOR THE MONTH OF"]
[null,{"$f":"DATA!C5","v":"00:00:00"},null,null,null,null,"(To be prepared by IA/HM and submit toMPDO)"]
[]
[null,{"$f":"CONCATENATE(\"Name of the Mandal:\",DATA!C6)","v":"Name of the Mandal:Balayapalli"},null,null,null,null,{"$f":"CONCATENATE(\"School Name & Place:\",DATA!C8)","v":"School Name & Place:ZPPHS,Balayapalli"}]
[null,{"$f":"CONCATENATE(\"Name of the Habitation:\",DATA!C7)","v":"Name of the Habitation:Balayapalli"},null,null,null,null,"MDM School Code:"]
[]
[null,{"$f":"CONCATENATE(\"Regular students:\",DATA!E9-DATA!E10,\"                                    \",\"Hostel Students:\",DATA!E10,\"                                    \",\"Total Roll:\",DATA!E9-DATA!E10+DATA!E10)","v":"Regular students:307                                    Hostel Students:73                                    Total Roll:380"}]
[null,{"$f":"CONCATENATE(\"IA Name & Address:\",DATA!C11)","v":"IA Name & Address:B.Polamma"}]
[]
[null,"DATE","DAY","(GEN) Children attended \nto School",null,null,"(GEN) No. of Children \nFed",null,null,"Cost for \nchild","Total \namount"]
[null,null,null,"VI \nTO \nVII","VIII \nTO \nX","Total","VI \nTO \nVII","VIII \nTO \nX","Total"]
[null,{"$f":"DATA!C5","v":"00:00:00"},{"$f":"B13","v":"00:00:00"},{"$f":"DATA!H5-DATA!H23-DATA!H41","v":70},{"$f":"DATA!M5-DATA!M23-DATA!M41","v":171},{"$f":"IF(D13=0,0,D13+E13)","v":241},{"$f":"IF(C13=\"Sunday\",\" \",D13)","v":70},{"$f":"IF(D13=\"Sunday\",\" \",E13)","v":171},{"$f":"IF(G13=0,0,G13+H13)","v":241},{"$f":"IF(I13=0,\" \",DATA!C15)","v":0},{"$f":"IF(I13=0,\" \",I13*J13)","v":0}]
[null,{"$f":"B13+1","v":"1900-01-01"},"1900-01-01",{"$f":"DATA!H6-DATA!H24-DATA!H42","v":70},{"$f":"DATA!M6-DATA!M24-DATA!M42","v":-82},-12,70,-82,-12,{"$f":"IF(I14=0,\" \",DATA!C15)","v":0},{"$f":"IF(I14=0,\" \",I14*J14)","v":0}]
[null,"1900-01-02","1900-01-02",{"$f":"DATA!H7-DATA!H25-DATA!H43","v":70},{"$f":"DATA!M7-DATA!M25-DATA!M43","v":-82},-12,70,-82,-12,{"$f":"IF(I15=0,\" \",DATA!C15)","v":0},{"$f":"IF(I15=0,\" \",I15*J15)","v":0}]
[null,"1900-01-03","1900-01-03",{"$f":"DATA!H8-DATA!H26-DATA!H44","v":70},{"$f":"DATA!M8-DATA!M26-DATA!M44","v":-82},-12,70,-82,-12,{"$f":"IF(I16=0,\" \",DATA!C15)","v":0},{"$f":"IF(I16=0,\" \",I16*J16)","v":0}]
[null,"1900-01-04","1900-01-04",{"$f":"DATA!H9-DATA!H27-DATA!H45","v":70},{"$f":"DATA!M9-DATA!M27-DATA!M45","v":-82},-12,70,-82,-12,{"$f":"IF(I17=0,\" \",DATA!C15)","v":0},{"$f":"IF(I17=0,\" \",I17*J17)","v":0}]
[null,"1900-01-05","1900-01-05",{"$f":"DATA!H10-DATA!H28-DATA!H46","v":70},{"$f":"DATA!M10-DATA!M28-DATA!M46","v":-82},-12,70,-82,-12,{"$f":"IF(I18=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-06","1900-01-06",{"$f":"DATA!H11-DATA!H29-DATA!H47","v":70},{"$f":"DATA!M11-DATA!M29-DATA!M47","v":-82},-12,70,-82,-12,{"$f":"IF(I19=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-07","1900-01-07",{"$f":"DATA!H12-DATA!H30-DATA!H48","v":70},{"$f":"DATA!M12-DATA!M30-DATA!M48","v":-82},-12,70,-82,-12,{"$f":"IF(I20=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-08","1900-01-08",{"$f":"DATA!H13-DATA!H31-DATA!H49","v":70},{"$f":"DATA!M13-DATA!M31-DATA!M49","v":-82},-12,70,-82,-12,{"$f":"IF(I21=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-09","1900-01-09",{"$f":"DATA!H14-DATA!H32-DATA!H50","v":70},{"$f":"DATA!M14-DATA!M32-DATA!M50","v":-82},-12,70,-82,-12,{"$f":"IF(I22=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-10","1900-01-10",{"$f":"DATA!H15-DATA!H33-DATA!H51","v":70},{"$f":"DATA!M15-DATA!M33-DATA!M51","v":-82},-12,70,-82,-12,{"$f":"IF(I23=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-11","1900-01-11",{"$f":"DATA!H16-DATA!H34-DATA!H52","v":70},{"$f":"DATA!M16-DATA!M34-DATA!M52","v":-82},-12,70,-82,-12,{"$f":"IF(I24=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-12","1900-01-12",{"$f":"DATA!H17-DATA!H35-DATA!H53","v":70},{"$f":"DATA!M17-DATA!M35-DATA!M53","v":-82},-12,70,-82,-12,{"$f":"IF(I25=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-13","1900-01-13",{"$f":"DATA!H18-DATA!H36-DATA!H54","v":70},{"$f":"DATA!M18-DATA!M36-DATA!M54","v":-82},-12,70,-82,-12,{"$f":"IF(I26=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-14","1900-01-14",{"$f":"DATA!H19-DATA!H37-DATA!H55","v":70},{"$f":"DATA!M19-DATA!M37-DATA!M55","v":-82},-12,70,-82,-12,{"$f":"IF(I27=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-15","1900-01-15",{"$f":"DATA!H20-DATA!H38-DATA!H56","v":199},{"$f":"DATA!M20-DATA!M38-DATA!M56","v":-82},117,199,-82,117,{"$f":"IF(I28=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-16","1900-01-16",{"$f":"DATA!J5-DATA!J23-DATA!J41","v":-53},{"$f":"DATA!O5-DATA!O23-DATA!O41","v":171},118,-53,171,118,{"$f":"IF(I29=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-17","1900-01-17",{"$f":"DATA!J6-DATA!J24-DATA!J42","v":-53},{"$f":"DATA!O6-DATA!O24-DATA!O42","v":-81},-134,-53,-81,-134,{"$f":"IF(I30=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-18","1900-01-18",{"$f":"DATA!J7-DATA!J25-DATA!J43","v":-53},{"$f":"DATA!O7-DATA!O25-DATA!O43","v":-81},-134,-53,-81,-134,{"$f":"IF(I31=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-19","1900-01-19",{"$f":"DATA!J8-DATA!J26-DATA!J44","v":-53},{"$f":"DATA!O8-DATA!O26-DATA!O44","v":-81},-134,-53,-81,-134,{"$f":"IF(I32=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-20","1900-01-20",{"$f":"DATA!J9-DATA!J27-DATA!J45","v":-53},{"$f":"DATA!O9-DATA!O27-DATA!O45","v":-81},-134,-53,-81,-134,{"$f":"IF(I33=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-21","1900-01-21",{"$f":"DATA!J10-DATA!J28-DATA!J46","v":-53},{"$f":"DATA!O10-DATA!O28-DATA!O46","v":-81},-134,-53,-81,-134,{"$f":"IF(I34=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-22","1900-01-22",{"$f":"DATA!J11-DATA!J29-DATA!J47","v":-53},{"$f":"DATA!O11-DATA!O29-DATA!O47","v":-81},-134,-53,-81,-134,{"$f":"IF(I35=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-23","1900-01-23",{"$f":"DATA!J12-DATA!J30-DATA!J48","v":-53},{"$f":"DATA!O12-DATA!O30-DATA!O48","v":-81},-134,-53,-81,-134,{"$f":"IF(I36=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-24","1900-01-24",{"$f":"DATA!J13-DATA!J31-DATA!J49","v":-53},{"$f":"DATA!O13-DATA!O31-DATA!O49","v":-81},-134,-53,-81,-134,{"$f":"IF(I37=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-25","1900-01-25",{"$f":"DATA!J14-DATA!J32-DATA!J50","v":-53},{"$f":"DATA!O14-DATA!O32-DATA!O50","v":-81},-134,-53,-81,-134,{"$f":"IF(I38=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-26","1900-01-26",{"$f":"DATA!J15-DATA!J33-DATA!J51","v":-53},{"$f":"DATA!O15-DATA!O33-DATA!O51","v":-81},-134,-53,-81,-134,{"$f":"IF(I39=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-27","1900-01-27",{"$f":"DATA!J16-DATA!J34-DATA!J52","v":-53},{"$f":"DATA!O16-DATA!O34-DATA!O52","v":-81},-134,-53,-81,-134,{"$f":"IF(I40=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-28","1900-01-28",{"$f":"DATA!J17-DATA!J35-DATA!J53","v":-53},{"$f":"DATA!O17-DATA!O35-DATA!O53","v":-81},-134,-53,-81,-134,{"$f":"IF(I41=0,\" \",DATA!C15)","v":0},0]
[null,"1900-01-29","1900-01-29",{"$f":"DATA!J18-DATA!J36-DATA!J54","v":-53},{"$f":"DATA!O18-DATA!O36-DATA!O54","v":-81},-134,-53,-81,-134,{"$f":"IF(I42=0,\" \",DATA!C15)","v":0},0]
[null,{"$f":"IF(DATA!J19>0,B42+1,0)","v":"1900-01-30"},"1900-01-30",{"$f":"DATA!J19-DATA!J37-DATA!J55","v":-53},{"$f":"DATA!O19-DATA!O37-DATA!O55","v":-81},-134,-53,-81,-134,{"$f":"IF(I43=0,\" \",DATA!C15)","v":0},0]
[null,"Total",null,{"$f":"SUM(D13:D43)","v":454},-2022,-1568,454,-2022,-1568,"Total",{"$f":"SUM(K13:K43)","v":0}]
[null,"Rice Particulars in KG's",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K44+SC!K44+ST!K44","v":0}]
[null,{"$f":"CONCATENATE(\"Opening Balance:\",SC!N49,\"          \",\"Rice received during Month:\",0,\"        \",\"Total rice:\",SC!N49,\"         \",\"Utalised:\",I44*0.15,\"           \",\"Balance:\",SC!N49-I44*0.15)","v":"Opening Balance:2188.8          Rice received during Month:0        Total rice:2188.8         Utalised:-235.2           Balance:2424"}]
[]
[]
[null,"Signature of the Chair person\n/Chairman of the Governing Body of the Aided School",null,null,null,null,null,"Signature of the authorised person \nof the Implementing Agency"]
[]
[]
[null,null,null,null,null,null,null,"Signature of the Head Master"]

{"sheet":"MDM VI To VIII","index":4,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,52,9],[2,1,52,1],[2,2,2,7],[3,2,3,3],[8,2,8,7],[11,2,12,2],[11,3,12,3],[44,2,44,3],[45,2,45,7],[46,2,46,7],[49,2,49,4],[49,6,49,7],[52,6,52,7],[5,5,5,7],[6,5,6,7],[53,6,53,7],[11,6,12,6],[11,7,12,7]]}
[]
[]
[null,null,{"$f":"CONCATENATE(\"DAY-WISE DETAILED VOUCHER FOR SERVING MID-DAY MEAL PROGRAMME FOR THE MONTH OF \")","v":"DAY-WISE DETAILED VOUCHER FOR SERVING MID-DAY MEAL PROGRAMME FOR THE MONTH OF "}]
[null,null,{"$f":"DATA!M97","v":"October 2010"},null,null,"(To be prepared by IA/HM and submit toMPDO)"]
[]
[null,null,{"$f":"CONCATENATE(\"Name of the Mandal:\",DATA!C6)","v":"Name of the Mandal:Balayapalli"},null,null,{"$f":"CONCATENATE(\"School Name & Place:\",DATA!C8)","v":"School Name & Place:ZPPHS,Balayapalli"}]
[null,null,{"$f":"CONCATENATE(\"Name of the Habitation:\",DATA!C7)","v":"Name of the Habitation:Balayapalli"},null,null,"                                       MDM School Code:"]
[]
[null,null,{"$f":"CONCATENATE(\"Regular students:\",DATA!E9-DATA!E10,\"                                    \",\"Hostel Students:\",DATA!E10,\"                                    \",\"Total Roll:\",DATA!E9-DATA!E10+DATA!E10)","v":"Regular students:307                                    Hostel Students:73                                    Total Roll:380"}]
[null,null,{"$f":"CONCATENATE(\"IA Name & Address:\",DATA!C11)","v":"IA Name & Address:B.Polamma"}]
[]
[null,null,"DATE","DAY","Children attended \nto School","No. of Children \nFed","Cost for \nchild","Total \namount"]
[null,null,null,null,"VI \nTO \nVIII","VI \nTO \nVIII"]
[null,null,{"$f":"DATA!J97","v":"2010-10-01"},{"$f":"C14","v":"2010-10-01"},{"$f":"DATA!H5","v":125},{"$f":"IF(D14=\"Sunday\",\" \",E14)","v":125},{"$f":"IF(F14>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F14>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F14),\" \")","v":"Rs.0"},{"$f":"F14*DATA!C15","v":0}]
[null,null,{"$f":"C14+1","v":"2010-10-02"},{"$f":"C15","v":"2010-10-02"},{"$f":"DATA!H6","v":125},{"$f":"IF(D15=\"Sunday\",\" \",E15)","v":125},{"$f":"IF(F15>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F15>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F15),\" \")","v":"Rs.0"},{"$f":"F15*DATA!C15","v":0}]
[null,null,{"$f":"C15+1","v":"2010-10-03"},"2010-10-03",{"$f":"DATA!H7","v":125},125,{"$f":"IF(F16>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F16>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F16),\" \")","v":"Rs.0"},{"$f":"F16*DATA!C15","v":0}]
[null,null,"2010-10-04","2010-10-04",{"$f":"DATA!H8","v":125},125,{"$f":"IF(F17>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F17>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F17),\" \")","v":"Rs.0"},{"$f":"F17*DATA!C15","v":0}]
[null,null,"2010-10-05","2010-10-05",{"$f":"DATA!H9","v":125},125,{"$f":"IF(F18>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F18>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F18),\" \")","v":"Rs.0"},{"$f":"F18*DATA!C15","v":0}]
[null,null,"2010-10-06","2010-10-06",{"$f":"DATA!H10","v":125},125,{"$f":"IF(F19>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F19>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F19),\" \")","v":"Rs.0"},{"$f":"F19*DATA!C15","v":0}]
[null,null,"2010-10-07","2010-10-07",{"$f":"DATA!H11","v":125},125,{"$f":"IF(F20>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F20>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F20),\" \")","v":"Rs.0"},{"$f":"F20*DATA!C15","v":0}]
[null,null,"2010-10-08","2010-10-08",{"$f":"DATA!H12","v":125},125,{"$f":"IF(F21>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F21>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F21),\" \")","v":"Rs.0"},{"$f":"F21*DATA!C15","v":0}]
[null,null,"2010-10-09","2010-10-09",{"$f":"DATA!H13","v":125},125,{"$f":"IF(F22>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F22>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F22),\" \")","v":"Rs.0"},{"$f":"F22*DATA!C15","v":0}]
[null,null,"2010-10-10","2010-10-10",{"$f":"DATA!H14","v":125},125,{"$f":"IF(F23>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F23>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F23),\" \")","v":"Rs.0"},{"$f":"F23*DATA!C15","v":0}]
[null,null,"2010-10-11","2010-10-11",{"$f":"DATA!H15","v":125},125,{"$f":"IF(F24>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F24>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F24),\" \")","v":"Rs.0"},{"$f":"F24*DATA!C15","v":0}]
[null,null,"2010-10-12","2010-10-12",{"$f":"DATA!H16","v":125},125,{"$f":"IF(F25>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F25>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F25),\" \")","v":"Rs.0"},{"$f":"F25*DATA!C15","v":0}]
[null,null,"2010-10-13","2010-10-13",{"$f":"DATA!H17","v":125},125,{"$f":"IF(F26>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F26>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F26),\" \")","v":"Rs.0"},{"$f":"F26*DATA!C15","v":0}]
[null,null,"2010-10-14","2010-10-14",{"$f":"DATA!H18","v":125},{"$f":"IF(D27=\"Sunday\",\" \",E27)","v":125},{"$f":"IF(F27>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F27>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F27),\" \")","v":"Rs.0"},{"$f":"F27*DATA!C15","v":0}]
[null,null,"2010-10-15","2010-10-15",{"$f":"DATA!H19","v":125},125,{"$f":"IF(F28>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F28>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F28),\" \")","v":"Rs.0"},{"$f":"F28*DATA!C15","v":0}]
[null,null,"2010-10-16","2010-10-16",{"$f":"DATA!H20","v":254},254,{"$f":"IF(F29>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F29>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F29),\" \")","v":"Rs.0"},{"$f":"F29*DATA!C15","v":0}]
[null,null,"2010-10-17","2010-10-17",{"$f":"DATA!J5","v":2},2,{"$f":"IF(F30>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F30>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F30),\" \")","v":"Rs.0"},{"$f":"F30*DATA!C15","v":0}]
[null,null,"2010-10-18","2010-10-18",{"$f":"DATA!J6","v":2},2,{"$f":"IF(F31>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F31>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F31),\" \")","v":"Rs.0"},{"$f":"F31*DATA!C15","v":0}]
[null,null,"2010-10-19","2010-10-19",{"$f":"DATA!J7","v":2},2,{"$f":"IF(F32>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F32>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F32),\" \")","v":"Rs.0"},{"$f":"F32*DATA!C15","v":0}]
[null,null,{"$f":"C32+1","v":"2010-10-20"},"2010-10-20",{"$f":"DATA!J8","v":2},2,{"$f":"IF(F33>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F33>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F33),\" \")","v":"Rs.0"},{"$f":"F33*DATA!C15","v":0}]
[null,null,"2010-10-21","2010-10-21",{"$f":"DATA!J9","v":2},2,{"$f":"IF(F34>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F34>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F34),\" \")","v":"Rs.0"},{"$f":"F34*DATA!C15","v":0}]
[null,null,"2010-10-22","2010-10-22",{"$f":"DATA!J10","v":2},2,{"$f":"IF(F35>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F35>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F35),\" \")","v":"Rs.0"},{"$f":"F35*DATA!C15","v":0}]
[null,null,"2010-10-23","2010-10-23",{"$f":"DATA!J11","v":2},2,{"$f":"IF(F36>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F36>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F36),\" \")","v":"Rs.0"},{"$f":"F36*DATA!C15","v":0}]
[null,null,"2010-10-24","2010-10-24",{"$f":"DATA!J12","v":2},2,{"$f":"IF(F37>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F37>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F37),\" \")","v":"Rs.0"},{"$f":"F37*DATA!C15","v":0}]
[null,null,"2010-10-25","2010-10-25",{"$f":"DATA!J13","v":2},2,{"$f":"IF(F38>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F38>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F38),\" \")","v":"Rs.0"},{"$f":"F38*DATA!C15","v":0}]
[null,null,"2010-10-26","2010-10-26",{"$f":"DATA!J14","v":2},2,{"$f":"IF(F39>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F39>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F39),\" \")","v":"Rs.0"},{"$f":"F39*DATA!C15","v":0}]
[null,null,"2010-10-27","2010-10-27",{"$f":"DATA!J15","v":2},2,{"$f":"IF(F40>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F40>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F40),\" \")","v":"Rs.0"},{"$f":"F40*DATA!C15","v":0}]
[null,null,"2010-10-28","2010-10-28",{"$f":"DATA!J16","v":2},2,{"$f":"IF(F41>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F41>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F41),\" \")","v":"Rs.0"},{"$f":"F41*DATA!C15","v":0}]
[null,null,"2010-10-29","2010-10-29",{"$f":"DATA!J17","v":2},2,{"$f":"IF(F42>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F42>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F42),\" \")","v":"Rs.0"},{"$f":"F42*DATA!C15","v":0}]
[null,null,"2010-10-30","2010-10-30",{"$f":"DATA!J18","v":2},2,{"$f":"IF(F43>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F43>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F43),\" \")","v":"Rs.0"},{"$f":"F43*DATA!C15","v":0}]
[null,null,{"$f":"IF(DATA!J19>0,C43+1,0)","v":"2010-10-31"},"2010-10-31",{"$f":"DATA!J19","v":2},2,{"$f":"IF(F44>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(F44>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM VI To VIII'!F44),\" \")","v":"Rs.0"},{"$f":"F44*DATA!C15","v":0}]
[null,null,"Total",null,{"$f":"SUM(E14:E44)","v":2159},{"$f":"SUM(F14:F44)","v":2159},"Total",{"$f":"CONCATENATE(\"Rs.\",SUM(I14:I44))","v":"Rs.0"}]
[]
[null,null,{"$f":"CONCATENATE(\"Opening Balance:\",DATA!C12,\"          \",\"Rice received during Month:\",DATA!C13,\"          \",\"Total rice:\",DATA!C12+DATA!C13,\"        \",\"Utalised:\",F45*0.15,\"         \",\"Balance:\",DATA!C12+DATA!C13-F45*0.15)","v":"Opening Balance:1330.5          Rice received during Month:1500          Total rice:2830.5        Utalised:323.85         Balance:2506.65"}]
[]
[]
[null,null,"Signature of the Chair person\n/Chairman of the Governing Body of the Aided School",null,null,null,"Signature of the authorised person \nof the Implementing Agency"]
[]
[]
[]
[null,null,null,null,null,null,"Signature of the Head Master"]

{"sheet":"MDM IX To X","index":5,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,8,51,8],[1,0,51,0],[1,1,1,6],[2,1,2,2],[4,4,4,6],[5,4,5,6],[7,1,7,6],[10,1,11,1],[10,2,11,2],[51,5,51,6],[50,5,50,6],[10,5,11,5],[10,6,11,6],[43,1,43,2],[44,1,44,6],[45,1,45,6],[48,1,48,3],[48,5,48,6]]}
[]
[null,{"$f":"CONCATENATE(\"DAY-WISE DETAILED VOUCHER FOR SERVING MID-DAY MEAL PROGRAMME FOR THE MONTH OF \")","v":"DAY-WISE DETAILED VOUCHER FOR SERVING MID-DAY MEAL PROGRAMME FOR THE MONTH OF "}]
[null,{"$f":"DATA!M97","v":"October 2010"},null,null,"(To be prepared by IA/HM and submit toMPDO)"]
[]
[null,{"$f":"CONCATENATE(\"Name of the Mandal:\",DATA!C6)","v":"Name of the Mandal:Balayapalli"},null,null,{"$f":"CONCATENATE(\"School Name & Place:\",DATA!C8)","v":"School Name & Place:ZPPHS,Balayapalli"}]
[null,{"$f":"CONCATENATE(\"Name of the Habitation:\",DATA!C7)","v":"Name of the Habitation:Balayapalli"},null,null,"                              MDM School Code:"]
[]
[null,{"$f":"CONCATENATE(\"Regular students:\",DATA!E9-DATA!E10,\"                                    \",\"Hostel Students:\",DATA!E10,\"                                    \",\"Total Roll:\",DATA!E9-DATA!E10+DATA!E10)","v":"Regular students:307                                    Hostel Students:73                                    Total Roll:380"}]
[null,{"$f":"CONCATENATE(\"IA Name & Address:\",DATA!C11)","v":"IA Name & Address:B.Polamma"}]
[]
[null,"DATE","DAY","Children attended \nto School","No. of Children \nFed","Cost for \nchild","Total \namount"]
[null,null,null,"XI \nTO \nX","XI \nTO \nX"]
[null,{"$f":"DATA!J97","v":"2010-10-01"},{"$f":"B13","v":"2010-10-01"},{"$f":"DATA!M5","v":254},{"$f":"IF(C13=\"Sunday\",\" \",D13)","v":254},{"$f":"IF(E13>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E13>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E13),\" \")","v":"Rs.0"},{"$f":"E13*DATA!C15","v":0}]
[null,{"$f":"B13+1","v":"2010-10-02"},{"$f":"B14","v":"2010-10-02"},{"$f":"DATA!M6","v":1},{"$f":"IF(C14=\"Sunday\",\" \",D14)","v":1},{"$f":"IF(E14>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E14>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E14),\" \")","v":"Rs.0"},{"$f":"E14*DATA!C15","v":0}]
[null,{"$f":"B14+1","v":"2010-10-03"},"2010-10-03",{"$f":"DATA!M7","v":1},1,{"$f":"IF(E15>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E15>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E15),\" \")","v":"Rs.0"},{"$f":"E15*DATA!C15","v":0}]
[null,"2010-10-04","2010-10-04",{"$f":"DATA!M8","v":1},1,{"$f":"IF(E16>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E16>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E16),\" \")","v":"Rs.0"},{"$f":"E16*DATA!C15","v":0}]
[null,"2010-10-05","2010-10-05",{"$f":"DATA!M9","v":1},1,{"$f":"IF(E17>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E17>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E17),\" \")","v":"Rs.0"},{"$f":"E17*DATA!C15","v":0}]
[null,"2010-10-06","2010-10-06",{"$f":"DATA!M10","v":1},1,{"$f":"IF(E18>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E18>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E18),\" \")","v":"Rs.0"},{"$f":"E18*DATA!C15","v":0}]
[null,"2010-10-07","2010-10-07",{"$f":"DATA!M11","v":1},1,{"$f":"IF(E19>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E19>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E19),\" \")","v":"Rs.0"},{"$f":"E19*DATA!C15","v":0}]
[null,"2010-10-08","2010-10-08",{"$f":"DATA!M12","v":1},1,{"$f":"IF(E20>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E20>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E20),\" \")","v":"Rs.0"},{"$f":"E20*DATA!C15","v":0}]
[null,"2010-10-09","2010-10-09",{"$f":"DATA!M13","v":1},1,{"$f":"IF(E21>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E21>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E21),\" \")","v":"Rs.0"},{"$f":"E21*DATA!C15","v":0}]
[null,"2010-10-10","2010-10-10",{"$f":"DATA!M14","v":1},1,{"$f":"IF(E22>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E22>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E22),\" \")","v":"Rs.0"},{"$f":"E22*DATA!C15","v":0}]
[null,"2010-10-11","2010-10-11",{"$f":"DATA!M15","v":1},1,{"$f":"IF(E23>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E23>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E23),\" \")","v":"Rs.0"},{"$f":"E23*DATA!C15","v":0}]
[null,"2010-10-12","2010-10-12",{"$f":"DATA!M16","v":1},1,{"$f":"IF(E24>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E24>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E24),\" \")","v":"Rs.0"},{"$f":"E24*DATA!C15","v":0}]
[null,"2010-10-13","2010-10-13",{"$f":"DATA!M17","v":1},1,{"$f":"IF(E25>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E25>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E25),\" \")","v":"Rs.0"},{"$f":"E25*DATA!C15","v":0}]
[null,"2010-10-14","2010-10-14",{"$f":"DATA!M18","v":1},{"$f":"IF(C26=\"Sunday\",\" \",D26)","v":1},{"$f":"IF(E26>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E26>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E26),\" \")","v":"Rs.0"},{"$f":"E26*DATA!C15","v":0}]
[null,"2010-10-15","2010-10-15",{"$f":"DATA!M19","v":1},1,{"$f":"IF(E27>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E27>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E27),\" \")","v":"Rs.0"},{"$f":"E27*DATA!C15","v":0}]
[null,"2010-10-16","2010-10-16",{"$f":"DATA!M20","v":1},1,{"$f":"IF(E28>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E28>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E28),\" \")","v":"Rs.0"},{"$f":"E28*DATA!C15","v":0}]
[null,"2010-10-17","2010-10-17",{"$f":"DATA!O5","v":254},254,{"$f":"IF(E29>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E29>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E29),\" \")","v":"Rs.0"},{"$f":"E29*DATA!C15","v":0}]
[null,"2010-10-18","2010-10-18",{"$f":"DATA!O6","v":2},2,{"$f":"IF(E30>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E30>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E30),\" \")","v":"Rs.0"},{"$f":"E30*DATA!C15","v":0}]
[null,"2010-10-19","2010-10-19",{"$f":"DATA!O7","v":2},2,{"$f":"IF(E31>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E31>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E31),\" \")","v":"Rs.0"},{"$f":"E31*DATA!C15","v":0}]
[null,{"$f":"B31+1","v":"2010-10-20"},"2010-10-20",{"$f":"DATA!O8","v":2},2,{"$f":"IF(E32>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E32>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E32),\" \")","v":"Rs.0"},{"$f":"E32*DATA!C15","v":0}]
[null,"2010-10-21","2010-10-21",{"$f":"DATA!O9","v":2},2,{"$f":"IF(E33>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E33>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E33),\" \")","v":"Rs.0"},{"$f":"E33*DATA!C15","v":0}]
[null,"2010-10-22","2010-10-22",{"$f":"DATA!O10","v":2},2,{"$f":"IF(E34>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E34>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E34),\" \")","v":"Rs.0"},{"$f":"E34*DATA!C15","v":0}]
[null,"2010-10-23","2010-10-23",{"$f":"DATA!O11","v":2},2,{"$f":"IF(E35>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E35>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E35),\" \")","v":"Rs.0"},{"$f":"E35*DATA!C15","v":0}]
[null,"2010-10-24","2010-10-24",{"$f":"DATA!O12","v":2},2,{"$f":"IF(E36>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E36>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E36),\" \")","v":"Rs.0"},{"$f":"E36*DATA!C15","v":0}]
[null,"2010-10-25","2010-10-25",{"$f":"DATA!O13","v":2},2,{"$f":"IF(E37>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E37>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E37),\" \")","v":"Rs.0"},{"$f":"E37*DATA!C15","v":0}]
[null,"2010-10-26","2010-10-26",{"$f":"DATA!O14","v":2},2,{"$f":"IF(E38>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E38>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E38),\" \")","v":"Rs.0"},{"$f":"E38*DATA!C15","v":0}]
[null,"2010-10-27","2010-10-27",{"$f":"DATA!O15","v":2},2,{"$f":"IF(E39>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E39>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E39),\" \")","v":"Rs.0"},{"$f":"E39*DATA!C15","v":0}]
[null,"2010-10-28","2010-10-28",{"$f":"DATA!O16","v":2},2,{"$f":"IF(E40>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E40>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E40),\" \")","v":"Rs.0"},{"$f":"E40*DATA!C15","v":0}]
[null,"2010-10-29","2010-10-29",{"$f":"DATA!O17","v":2},2,{"$f":"IF(E41>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E41>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E41),\" \")","v":"Rs.0"},{"$f":"E41*DATA!C15","v":0}]
[null,"2010-10-30","2010-10-30",{"$f":"DATA!O18","v":2},2,{"$f":"IF(E42>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E42>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E42),\" \")","v":"Rs.0"},{"$f":"E42*DATA!C15","v":0}]
[null,{"$f":"IF(DATA!J19>0,B42+1,0)","v":"2010-10-31"},"2010-10-31",{"$f":"DATA!O19","v":2},2,{"$f":"IF(E43>0,CONCATENATE(\"Rs.\",DATA!C15),\" \")","v":"Rs."},{"$f":"IF(E43>0,CONCATENATE(,\"Rs.\",DATA!C15*'MDM IX To X'!E43),\" \")","v":"Rs.0"},{"$f":"E43*DATA!C15","v":0}]
[null,"Total",null,{"$f":"SUM(D13:D43)","v":551},{"$f":"SUM(E13:E43)","v":551},"Total",{"$f":"CONCATENATE(\"Rs.\",SUM(H13:H43))","v":"Rs.0"}]
[]
[null,{"$f":"CONCATENATE(\"Opening Balance:\",DATA!C12+DATA!C13-'MDM VI To VIII'!F45*0.15,\"               \",\"Rice received during Month:\",0,\"           \",\"Total rice:\",DATA!C12+DATA!C13-'MDM VI To VIII'!F45*0.15,\"            \",\"Utalised:\",E44*0.15,\"          \",\"Balance:\",DATA!C12+DATA!C13-'MDM VI To VIII'!F45*0.15-E44*0.15)","v":"Opening Balance:2506.65               Rice received during Month:0           Total rice:2506.65            Utalised:82.65          Balance:2424"}]
[]
[]
[null,"Signature of the Chair person\n/Chairman of the Governing Body of the Aided School",null,null,null,"Signature of the authorised person \nof the Implementing Agency"]
[]
[null,null,null,null,null,"Signature of the Head Master"]

{"sheet":"MDM VI to X","index":6,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,10],[0,11,51,11],[1,0,51,0],[44,1,44,10],[45,1,45,10],[48,1,48,3],[48,7,48,10],[43,1,43,2],[7,1,7,10],[1,1,1,10],[2,1,2,2],[10,1,11,1],[10,2,11,2],[10,9,11,9],[10,10,11,10],[10,3,10,5],[10,6,10,8],[51,7,51,10],[44,13,44,14],[45,13,45,14],[46,13,46,14]]}
[]
[null,"DAY-WISE DETAILED VOUCHER FOR SERVING MID-DAY MEAL PROGRAMME FOR THE MONTH OF"]
[null,{"$f":"DATA!M97","v":"October 2010"},null,null,null,null,"(To be prepared by IA/HM and submit toMPDO)"]
[]
[null,{"$f":"CONCATENATE(\"Name of the Mandal:\",DATA!C6)","v":"Name of the Mandal:Balayapalli"},null,null,null,null,{"$f":"CONCATENATE(\"School Name & Place:\",DATA!C8)","v":"School Name & Place:ZPPHS,Balayapalli"}]
[null,{"$f":"CONCATENATE(\"Name of the Habitation:\",DATA!C7)","v":"Name of the Habitation:Balayapalli"},null,null,null,null,"MDM School Code:"]
[]
[null,{"$f":"CONCATENATE(\"Regular students:\",DATA!E9-DATA!E10,\"                                    \",\"Hostel Students:\",DATA!E10,\"                                    \",\"Total Roll:\",DATA!E9-DATA!E10+DATA!E10)","v":"Regular students:307                                    Hostel Students:73                                    Total Roll:380"}]
[null,{"$f":"CONCATENATE(\"IA Name & Address:\",DATA!C11)","v":"IA Name & Address:B.Polamma"}]
[]
[null,"DATE","DAY","Children attended \nto School",null,null,"No. of Children \nFed",null,null,"Cost for \nchild","Total \namount"]
[null,null,null,"VI \nTO \nVII","VIII \nTO \nX","Total","VI \nTO \nVII","VIII \nTO \nX","Total"]
[null,{"$f":"DATA!J97","v":"2010-10-01"},{"$f":"B13","v":"2010-10-01"},{"$f":"DATA!H5","v":125},{"$f":"DATA!M5","v":254},{"$f":"IF(D13=0,0,D13+E13)","v":379},{"$f":"IF(C13=\"Sunday\",\" \",D13)","v":125},{"$f":"IF(D13=\"Sunday\",\" \",E13)","v":254},{"$f":"IF(G13=0,0,G13+H13)","v":379},{"$f":"IF(I13=0,\" \",DATA!C15)","v":0},{"$f":"IF(I13=0,\" \",I13*'MDM VI to X'!J13)","v":0}]
[null,{"$f":"B13+1","v":"2010-10-02"},{"$f":"B14","v":"2010-10-02"},{"$f":"DATA!H6","v":125},{"$f":"DATA!M6","v":1},126,{"$f":"IF(C14=\"Sunday\",\" \",D14)","v":125},{"$f":"IF(D14=\"Sunday\",\" \",E14)","v":1},126,{"$f":"IF(I14=0,\" \",DATA!C15)","v":0},{"$f":"IF(I14=0,\" \",I14*'MDM VI to X'!J14)","v":0}]
[null,{"$f":"B14+1","v":"2010-10-03"},"2010-10-03",{"$f":"DATA!H7","v":125},{"$f":"DATA!M7","v":1},126,125,1,126,{"$f":"IF(I15=0,\" \",DATA!C15)","v":0},{"$f":"IF(I15=0,\" \",I15*'MDM VI to X'!J15)","v":0}]
[null,"2010-10-04","2010-10-04",{"$f":"DATA!H8","v":125},{"$f":"DATA!M8","v":1},126,125,1,{"$f":"IF(G16=0,0,G16+H16)","v":126},{"$f":"IF(I16=0,\" \",DATA!C15)","v":0},{"$f":"IF(I16=0,\" \",I16*'MDM VI to X'!J16)","v":0}]
[null,"2010-10-05","2010-10-05",{"$f":"DATA!H9","v":125},{"$f":"DATA!M9","v":1},126,125,1,126,{"$f":"IF(I17=0,\" \",DATA!C15)","v":0},{"$f":"IF(I17=0,\" \",I17*'MDM VI to X'!J17)","v":0}]
[null,"2010-10-06","2010-10-06",{"$f":"DATA!H10","v":125},{"$f":"DATA!M10","v":1},126,125,1,126,{"$f":"IF(I18=0,\" \",DATA!C15)","v":0},{"$f":"IF(I18=0,\" \",I18*'MDM VI to X'!J18)","v":0}]
[null,"2010-10-07","2010-10-07",{"$f":"DATA!H11","v":125},{"$f":"DATA!M11","v":1},126,125,1,126,{"$f":"IF(I19=0,\" \",DATA!C15)","v":0},{"$f":"IF(I19=0,\" \",I19*'MDM VI to X'!J19)","v":0}]
[null,"2010-10-08","2010-10-08",{"$f":"DATA!H12","v":125},{"$f":"DATA!M12","v":1},126,125,1,126,{"$f":"IF(I20=0,\" \",DATA!C15)","v":0},{"$f":"IF(I20=0,\" \",I20*'MDM VI to X'!J20)","v":0}]
[null,"2010-10-09","2010-10-09",{"$f":"DATA!H13","v":125},{"$f":"DATA!M13","v":1},126,125,1,126,{"$f":"IF(I21=0,\" \",DATA!C15)","v":0},{"$f":"IF(I21=0,\" \",I21*'MDM VI to X'!J21)","v":0}]
[null,"2010-10-10","2010-10-10",{"$f":"DATA!H14","v":125},{"$f":"DATA!M14","v":1},126,125,1,126,{"$f":"IF(I22=0,\" \",DATA!C15)","v":0},{"$f":"IF(I22=0,\" \",I22*'MDM VI to X'!J22)","v":0}]
[null,"2010-10-11","2010-10-11",{"$f":"DATA!H15","v":125},{"$f":"DATA!M15","v":1},126,125,1,126,{"$f":"IF(I23=0,\" \",DATA!C15)","v":0},{"$f":"IF(I23=0,\" \",I23*'MDM VI to X'!J23)","v":0}]
[null,"2010-10-12","2010-10-12",{"$f":"DATA!H16","v":125},{"$f":"DATA!M16","v":1},126,125,1,126,{"$f":"IF(I24=0,\" \",DATA!C15)","v":0},{"$f":"IF(I24=0,\" \",I24*'MDM VI to X'!J24)","v":0}]
[null,"2010-10-13","2010-10-13",{"$f":"DATA!H17","v":125},{"$f":"DATA!M17","v":1},126,125,1,126,{"$f":"IF(I25=0,\" \",DATA!C15)","v":0},{"$f":"IF(I25=0,\" \",I25*'MDM VI to X'!J25)","v":0}]
[null,"2010-10-14","2010-10-14",{"$f":"DATA!H18","v":125},{"$f":"DATA!M18","v":1},126,125,1,126,{"$f":"IF(I26=0,\" \",DATA!C15)","v":0},{"$f":"IF(I26=0,\" \",I26*'MDM VI to X'!J26)","v":0}]
[null,"2010-10-15","2010-10-15",{"$f":"DATA!H19","v":125},{"$f":"DATA!M19","v":1},126,125,1,126,{"$f":"IF(I27=0,\" \",DATA!C15)","v":0},{"$f":"IF(I27=0,\" \",I27*'MDM VI to X'!J27)","v":0}]
[null,"2010-10-16","2010-10-16",{"$f":"DATA!H20","v":254},{"$f":"DATA!M20","v":1},255,254,1,255,{"$f":"IF(I28=0,\" \",DATA!C15)","v":0},{"$f":"IF(I28=0,\" \",I28*'MDM VI to X'!J28)","v":0}]
[null,"2010-10-17","2010-10-17",{"$f":"DATA!J5","v":2},{"$f":"DATA!O5","v":254},256,2,254,256,{"$f":"IF(I29=0,\" \",DATA!C15)","v":0},{"$f":"IF(I29=0,\" \",I29*'MDM VI to X'!J29)","v":0}]
[null,"2010-10-18","2010-10-18",{"$f":"DATA!J6","v":2},{"$f":"DATA!O6","v":2},4,2,2,4,{"$f":"IF(I30=0,\" \",DATA!C15)","v":0},{"$f":"IF(I30=0,\" \",I30*'MDM VI to X'!J30)","v":0}]
[null,"2010-10-19","2010-10-19",{"$f":"DATA!J7","v":2},{"$f":"DATA!O7","v":2},4,2,2,4,{"$f":"IF(I31=0,\" \",DATA!C15)","v":0},{"$f":"IF(I31=0,\" \",I31*'MDM VI to X'!J31)","v":0}]
[null,{"$f":"B31+1","v":"2010-10-20"},"2010-10-20",{"$f":"DATA!J8","v":2},{"$f":"DATA!O8","v":2},4,2,2,4,{"$f":"IF(I32=0,\" \",DATA!C15)","v":0},{"$f":"IF(I32=0,\" \",I32*'MDM VI to X'!J32)","v":0}]
[null,"2010-10-21","2010-10-21",{"$f":"DATA!J9","v":2},{"$f":"DATA!O9","v":2},4,2,2,4,{"$f":"IF(I33=0,\" \",DATA!C15)","v":0},{"$f":"IF(I33=0,\" \",I33*'MDM VI to X'!J33)","v":0}]
[null,"2010-10-22","2010-10-22",{"$f":"DATA!J10","v":2},{"$f":"DATA!O10","v":2},4,2,2,4,{"$f":"IF(I34=0,\" \",DATA!C15)","v":0},{"$f":"IF(I34=0,\" \",I34*'MDM VI to X'!J34)","v":0}]
[null,"2010-10-23","2010-10-23",{"$f":"DATA!J11","v":2},{"$f":"DATA!O11","v":2},4,2,2,4,{"$f":"IF(I35=0,\" \",DATA!C15)","v":0},{"$f":"IF(I35=0,\" \",I35*'MDM VI to X'!J35)","v":0}]
[null,"2010-10-24","2010-10-24",{"$f":"DATA!J12","v":2},{"$f":"DATA!O12","v":2},4,2,2,4,{"$f":"IF(I36=0,\" \",DATA!C15)","v":0},{"$f":"IF(I36=0,\" \",I36*'MDM VI to X'!J36)","v":0}]
[null,"2010-10-25","2010-10-25",{"$f":"DATA!J13","v":2},{"$f":"DATA!O13","v":2},4,2,2,4,{"$f":"IF(I37=0,\" \",DATA!C15)","v":0},{"$f":"IF(I37=0,\" \",I37*'MDM VI to X'!J37)","v":0}]
[null,"2010-10-26","2010-10-26",{"$f":"DATA!J14","v":2},{"$f":"DATA!O14","v":2},4,2,2,4,{"$f":"IF(I38=0,\" \",DATA!C15)","v":0},{"$f":"IF(I38=0,\" \",I38*'MDM VI to X'!J38)","v":0}]
[null,"2010-10-27","2010-10-27",{"$f":"DATA!J15","v":2},{"$f":"DATA!O15","v":2},4,2,2,4,{"$f":"IF(I39=0,\" \",DATA!C15)","v":0},{"$f":"IF(I39=0,\" \",I39*'MDM VI to X'!J39)","v":0}]
[null,"2010-10-28","2010-10-28",{"$f":"DATA!J16","v":2},{"$f":"DATA!O16","v":2},4,2,2,4,{"$f":"IF(I40=0,\" \",DATA!C15)","v":0},{"$f":"IF(I40=0,\" \",I40*'MDM VI to X'!J40)","v":0}]
[null,"2010-10-29","2010-10-29",{"$f":"DATA!J17","v":2},{"$f":"DATA!O17","v":2},4,2,2,4,{"$f":"IF(I41=0,\" \",DATA!C15)","v":0},{"$f":"IF(I41=0,\" \",I41*'MDM VI to X'!J41)","v":0}]
[null,"2010-10-30","2010-10-30",{"$f":"DATA!J18","v":2},{"$f":"DATA!O18","v":2},4,2,2,4,{"$f":"IF(I42=0,\" \",DATA!C15)","v":0},{"$f":"IF(I42=0,\" \",I42*'MDM VI to X'!J42)","v":0}]
[null,{"$f":"IF(DATA!J19>0,B42+1,0)","v":"2010-10-31"},"2010-10-31",{"$f":"DATA!J19","v":2},{"$f":"DATA!O19","v":2},4,2,2,4,{"$f":"IF(I43=0,\" \",DATA!C15)","v":0},{"$f":"IF(I43=0,\" \",I43*'MDM VI to X'!J43)","v":0}]
[null,"Total",null,{"$f":"SUM(D13:D43)","v":2159},{"$f":"SUM(E13:E43)","v":551},{"$f":"SUM(F13:F43)","v":2710},2159,551,2710,"Total",0]
[null,"Rice Particulars in KG's",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'MDM VI To VIII'!H45","v":"Rs.0"},null,"VI To VIII"]
[null,{"$f":"CONCATENATE(\"Opening Balance:\",DATA!C12,\"          \",\"Rice received during Month:\",DATA!C13,\"        \",\"Total rice:\",DATA!C12+DATA!C13,\"         \",\"Utalised:\",I44*0.15,\"           \",\"Balance:\",DATA!C12+DATA!C13-I44*0.15)","v":"Opening Balance:1330.5          Rice received during Month:1500        Total rice:2830.5         Utalised:406.5           Balance:2424"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'MDM IX To X'!G44","v":"Rs.0"},null,"IX To X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Rs.\"&'MDM VI To VIII'!F45*DATA!C15+'MDM IX To X'!E44*DATA!C15","v":"Rs.0"},null,"Total"]
[]
[null,"Signature of the Chair person\n/Chairman of the Governing Body of the Aided School",null,null,null,null,null,"Signature of the authorised person \nof the Implementing Agency"]
[]
[]
[null,null,null,null,null,null,null,"Signature of the Head Master"]

{"sheet":"Register VI to VIII & IX To X","index":7,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
[{"$f":"DATA!M97","v":"October 2010"}]
["Date","VI To VIII","IX TO X ","Total","Opening\n balance","Rice \nReceived\nFrom FP","Total \nRice","VI To VIII","IX TO X ","Total \nConsumption","Closing \nBalance","VI To VIII\nAmount","IX to X\nAmount","Total\nAmount"]
[{"$f":"'MDM VI to X'!B13","v":"2010-10-01"},{"$f":"'MDM VI To VIII'!E14","v":125},{"$f":"DATA!M5","v":254},{"$f":"C3+B3","v":379},{"$f":"DATA!C12","v":1330.5},{"$f":"IF(DATA!$E$13=DAY(A3),DATA!C13,0)","v":0},{"$f":"E3+F3","v":1330.5},{"$f":"B3*0.15","v":18.75},{"$f":"C3*0.15","v":38.1},{"$f":"H3+I3","v":56.85},{"$f":"G3-J3","v":1273.6500000000001},{"$f":"B3*DATA!C15","v":0},{"$f":"C3*DATA!C15","v":0},{"$f":"L3+M3","v":0}]
[{"$f":"'MDM VI to X'!B14","v":"2010-10-02"},{"$f":"'MDM VI To VIII'!E15","v":125},{"$f":"DATA!M6","v":1},{"$f":"C4+B4","v":126},{"$f":"K3","v":1273.6500000000001},{"$f":"IF(DATA!$E$13=DAY(A4),DATA!C13,0)","v":0},{"$f":"E4+F4","v":1273.6500000000001},{"$f":"B4*0.15","v":18.75},0.15,{"$f":"H4+I4","v":18.899999999999999},{"$f":"G4-J4","v":1254.75},{"$f":"B4*DATA!C15","v":0},{"$f":"C4*DATA!C15","v":0},{"$f":"L4+M4","v":0}]
[{"$f":"'MDM VI to X'!B15","v":"2010-10-03"},{"$f":"'MDM VI To VIII'!E16","v":125},{"$f":"DATA!M7","v":1},126,{"$f":"K4","v":1254.75},{"$f":"IF(DATA!$E$13=DAY(A5),DATA!C13,0)","v":0},1254.75,18.75,0.15,18.899999999999999,1235.8499999999999,{"$f":"B5*DATA!C15","v":0},{"$f":"C5*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B16","v":"2010-10-04"},{"$f":"'MDM VI To VIII'!E17","v":125},{"$f":"DATA!M8","v":1},126,1235.8499999999999,{"$f":"IF(DATA!$E$13=DAY(A6),DATA!C13,0)","v":0},1235.8499999999999,18.75,0.15,18.899999999999999,1216.9499999999998,{"$f":"B6*DATA!C15","v":0},{"$f":"C6*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B17","v":"2010-10-05"},{"$f":"'MDM VI To VIII'!E18","v":125},{"$f":"DATA!M9","v":1},126,1216.9499999999998,{"$f":"IF(DATA!$E$13=DAY(A7),DATA!C13,0)","v":1500},2716.95,18.75,0.15,18.899999999999999,2698.0499999999997,{"$f":"B7*DATA!C15","v":0},{"$f":"C7*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B18","v":"2010-10-06"},{"$f":"'MDM VI To VIII'!E19","v":125},{"$f":"DATA!M10","v":1},126,2698.0499999999997,null,2698.0499999999997,18.75,0.15,18.899999999999999,2679.1499999999996,{"$f":"B8*DATA!C15","v":0},{"$f":"C8*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B19","v":"2010-10-07"},{"$f":"'MDM VI To VIII'!E20","v":125},{"$f":"DATA!M11","v":1},126,2679.1499999999996,{"$f":"IF(DATA!$E$13=DAY(A9),DATA!C13,0)","v":0},2679.1499999999996,18.75,0.15,18.899999999999999,2660.2499999999995,{"$f":"B9*DATA!C15","v":0},{"$f":"C9*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B20","v":"2010-10-08"},{"$f":"'MDM VI To VIII'!E21","v":125},{"$f":"DATA!M12","v":1},126,2660.2499999999995,{"$f":"IF(DATA!$E$13=DAY(A10),DATA!C13,0)","v":0},2660.2499999999995,18.75,0.15,18.899999999999999,2641.3499999999995,{"$f":"B10*DATA!C15","v":0},{"$f":"C10*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B21","v":"2010-10-09"},{"$f":"'MDM VI To VIII'!E22","v":125},{"$f":"DATA!M13","v":1},126,2641.3499999999995,{"$f":"IF(DATA!$E$13=DAY(A11),DATA!C13,0)","v":0},2641.3499999999995,18.75,0.15,18.899999999999999,2622.4499999999994,{"$f":"B11*DATA!C15","v":0},{"$f":"C11*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B22","v":"2010-10-10"},{"$f":"'MDM VI To VIII'!E23","v":125},{"$f":"DATA!M14","v":1},126,2622.4499999999994,{"$f":"IF(DATA!$E$13=DAY(A12),DATA!C13,0)","v":0},2622.4499999999994,18.75,0.15,18.899999999999999,2603.5499999999993,{"$f":"B12*DATA!C15","v":0},{"$f":"C12*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B23","v":"2010-10-11"},{"$f":"'MDM VI To VIII'!E24","v":125},{"$f":"DATA!M15","v":1},126,2603.5499999999993,{"$f":"IF(DATA!$E$13=DAY(A13),DATA!C13,0)","v":0},2603.5499999999993,18.75,0.15,18.899999999999999,2584.6499999999992,{"$f":"B13*DATA!C15","v":0},{"$f":"C13*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B24","v":"2010-10-12"},{"$f":"'MDM VI To VIII'!E25","v":125},{"$f":"DATA!M16","v":1},126,2584.6499999999992,{"$f":"IF(DATA!$E$13=DAY(A14),DATA!C13,0)","v":0},2584.6499999999992,18.75,0.15,18.899999999999999,2565.7499999999991,{"$f":"B14*DATA!C15","v":0},{"$f":"C14*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B25","v":"2010-10-13"},{"$f":"'MDM VI To VIII'!E26","v":125},{"$f":"DATA!M17","v":1},126,2565.7499999999991,{"$f":"IF(DATA!$E$13=DAY(A15),DATA!C13,0)","v":0},2565.7499999999991,18.75,0.15,18.899999999999999,2546.849999999999,{"$f":"B15*DATA!C15","v":0},{"$f":"C15*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B26","v":"2010-10-14"},{"$f":"'MDM VI To VIII'!E27","v":125},{"$f":"DATA!M18","v":1},126,2546.849999999999,{"$f":"IF(DATA!$E$13=DAY(A16),DATA!C13,0)","v":0},2546.849999999999,18.75,0.15,18.899999999999999,2527.9499999999989,{"$f":"B16*DATA!C15","v":0},{"$f":"C16*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B27","v":"2010-10-15"},{"$f":"'MDM VI To VIII'!E28","v":125},{"$f":"DATA!M19","v":1},126,2527.9499999999989,{"$f":"IF(DATA!$E$13=DAY(A17),DATA!C13,0)","v":0},2527.9499999999989,18.75,0.15,18.899999999999999,2509.0499999999988,{"$f":"B17*DATA!C15","v":0},{"$f":"C17*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B28","v":"2010-10-16"},{"$f":"'MDM VI To VIII'!E29","v":254},{"$f":"DATA!M20","v":1},255,2509.0499999999988,{"$f":"IF(DATA!$E$13=DAY(A18),DATA!C13,0)","v":0},2509.0499999999988,38.1,0.15,38.25,2470.7999999999988,{"$f":"B18*DATA!C15","v":0},{"$f":"C18*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B29","v":"2010-10-17"},{"$f":"'MDM VI To VIII'!E30","v":2},{"$f":"DATA!O5","v":254},256,2470.7999999999988,{"$f":"IF(DATA!$E$13=DAY(A19),DATA!C13,0)","v":0},2470.7999999999988,0.3,38.1,38.4,2432.3999999999987,{"$f":"B19*DATA!C15","v":0},{"$f":"C19*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B30","v":"2010-10-18"},{"$f":"'MDM VI To VIII'!E31","v":2},{"$f":"DATA!O6","v":2},4,2432.3999999999987,null,2432.3999999999987,{"$f":"B20*0.15","v":0.3},0.3,0.6,2431.7999999999988,{"$f":"B20*DATA!C15","v":0},{"$f":"C20*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B31","v":"2010-10-19"},{"$f":"'MDM VI To VIII'!E32","v":2},{"$f":"DATA!O7","v":2},4,2431.7999999999988,{"$f":"IF(DATA!$E$13=DAY(A21),DATA!C13,0)","v":0},2431.7999999999988,0.3,0.3,0.6,2431.1999999999989,{"$f":"B21*DATA!C15","v":0},{"$f":"C21*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B32","v":"2010-10-20"},{"$f":"'MDM VI To VIII'!E33","v":2},{"$f":"DATA!O8","v":2},4,2431.1999999999989,{"$f":"IF(DATA!$E$13=DAY(A22),DATA!C13,0)","v":0},2431.1999999999989,0.3,0.3,0.6,2430.599999999999,{"$f":"B22*DATA!C15","v":0},{"$f":"C22*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B33","v":"2010-10-21"},{"$f":"'MDM VI To VIII'!E34","v":2},{"$f":"DATA!O9","v":2},4,2430.599999999999,{"$f":"IF(DATA!$E$13=DAY(A23),DATA!C13,0)","v":0},2430.599999999999,0.3,0.3,0.6,2429.9999999999991,{"$f":"B23*DATA!C15","v":0},{"$f":"C23*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B34","v":"2010-10-22"},{"$f":"'MDM VI To VIII'!E35","v":2},{"$f":"DATA!O10","v":2},4,2429.9999999999991,{"$f":"IF(DATA!$E$13=DAY(A24),DATA!C13,0)","v":0},2429.9999999999991,0.3,0.3,0.6,2429.3999999999992,{"$f":"B24*DATA!C15","v":0},{"$f":"C24*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B35","v":"2010-10-23"},{"$f":"'MDM VI To VIII'!E36","v":2},{"$f":"DATA!O11","v":2},4,2429.3999999999992,{"$f":"IF(DATA!$E$13=DAY(A25),DATA!C13,0)","v":0},2429.3999999999992,0.3,0.3,0.6,2428.7999999999993,{"$f":"B25*DATA!C15","v":0},{"$f":"C25*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B36","v":"2010-10-24"},{"$f":"'MDM VI To VIII'!E37","v":2},{"$f":"DATA!O12","v":2},4,2428.7999999999993,{"$f":"IF(DATA!$E$13=DAY(A26),DATA!C13,0)","v":0},2428.7999999999993,0.3,0.3,0.6,2428.1999999999994,{"$f":"B26*DATA!C15","v":0},{"$f":"C26*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B37","v":"2010-10-25"},{"$f":"'MDM VI To VIII'!E38","v":2},{"$f":"DATA!O13","v":2},4,2428.1999999999994,{"$f":"IF(DATA!$E$13=DAY(A27),DATA!C13,0)","v":0},2428.1999999999994,0.3,0.3,0.6,2427.5999999999995,{"$f":"B27*DATA!C15","v":0},{"$f":"C27*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B38","v":"2010-10-26"},{"$f":"'MDM VI To VIII'!E39","v":2},{"$f":"DATA!O14","v":2},4,2427.5999999999995,{"$f":"IF(DATA!$E$13=DAY(A28),DATA!C13,0)","v":0},2427.5999999999995,0.3,0.3,0.6,2426.9999999999995,{"$f":"B28*DATA!C15","v":0},{"$f":"C28*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B39","v":"2010-10-27"},{"$f":"'MDM VI To VIII'!E40","v":2},{"$f":"DATA!O15","v":2},4,2426.9999999999995,{"$f":"IF(DATA!$E$13=DAY(A29),DATA!C13,0)","v":0},2426.9999999999995,0.3,0.3,0.6,2426.3999999999996,{"$f":"B29*DATA!C15","v":0},{"$f":"C29*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B40","v":"2010-10-28"},{"$f":"'MDM VI To VIII'!E41","v":2},{"$f":"DATA!O16","v":2},4,2426.3999999999996,{"$f":"IF(DATA!$E$13=DAY(A30),DATA!C13,0)","v":0},2426.3999999999996,0.3,0.3,0.6,2425.7999999999997,{"$f":"B30*DATA!C15","v":0},{"$f":"C30*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B41","v":"2010-10-29"},{"$f":"'MDM VI To VIII'!E42","v":2},{"$f":"DATA!O17","v":2},4,2425.7999999999997,{"$f":"IF(DATA!$E$13=DAY(A31),DATA!C13,0)","v":0},2425.7999999999997,0.3,0.3,0.6,2425.1999999999998,{"$f":"B31*DATA!C15","v":0},{"$f":"C31*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B42","v":"2010-10-30"},{"$f":"'MDM VI To VIII'!E43","v":2},{"$f":"DATA!O18","v":2},4,2425.1999999999998,{"$f":"IF(DATA!$E$13=DAY(A32),DATA!C13,0)","v":0},2425.1999999999998,0.3,0.3,0.6,2424.6,{"$f":"B32*DATA!C15","v":0},{"$f":"C32*DATA!C15","v":0},0]
[{"$f":"'MDM VI to X'!B43","v":"2010-10-31"},{"$f":"'MDM VI To VIII'!E44","v":2},{"$f":"DATA!O19","v":2},{"$f":"C33+B33","v":4},{"$f":"IF(B33>0,K32,0)","v":2424.6},{"$f":"IF(DATA!$E$13=DAY(A33),DATA!C13,0)","v":0},{"$f":"E33+F33","v":2424.6},{"$f":"B33*0.15","v":0.3},{"$f":"C33*0.15","v":0.3},{"$f":"H33+I33","v":0.6},{"$f":"G33-J33","v":2424},{"$f":"B33*DATA!C15","v":0},{"$f":"C33*DATA!C15","v":0},{"$f":"L33+M33","v":0}]
["Total",{"$f":"SUM(B3:B33)","v":2159},551,2710,71420.549999999988,1500,72920.549999999988,323.85000000000019,82.649999999999949,406.50000000000028,72514.049999999988,0,0,0]

{"sheet":"register","index":8,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[1,25,3,25],[1,26,3,26],[1,27,3,27],[1,28,3,28],[2,23,3,23],[2,24,3,24],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,17,2,20],[2,21,3,21],[2,22,3,22],[2,7,3,7],[0,0,0,13],[0,14,0,28],[1,0,3,0],[1,1,3,1],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,20],[1,21,1,24],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6]]}
["MID-DAY MEAL PROGRAM ",null,null,null,null,null,null,null,null,null,null,null,null,null,"DAILY WATCH REGISTER"]
["Date","Day","Number on Roll (Including\nHostlers)",null,null,"Number on Hostlers",null,null,"Number Attanded",null,null,"Number Already taken MDM",null,null,"Rice",null,null,null,null,null,null,"Conversion cost payaable to IMA \nas per the number actually MDM taken",null,null,null,"Signature Of Head Master","Signature Of the IMA","Signature Of Visiting officer\n/Parents/Others","Remarks(Adverse events if any)"]
[null,null,"VI To VIII \nClasses","IX To X \nClasses","Total\nRoll","VI To VIII \nClasses","IX To X \nClasses","Total\nHostlers","VI To VIII \nClasses","IX To X \nClasses","Total\nAttended","VI To VIII \nClasses","IX To X \nClasses","Total\nMDM\nTaken","Opening \nBalance of Rice","Rice Received\n F.P Shop","Total Rice","Rice Consumption \nas per MDM taken Pupil",null,null,null,"Rate as per \nschool strength","VI To VIII \nClasses\nRs.","IX To X \nClasses\nRs.","Total\nRS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI To VIII \nClasses\n@150 g","IX To X \nClasses\n@150 g","Total\nConsumption","Closeing \nBalance of Rice"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[{"$f":"'MDM VI to X'!B13","v":"2010-10-01"},{"$f":"A6","v":"2010-10-01"},{"$f":"DATA!$E$9","v":380},null,null,null,null,null,null,null,null,null,null,null,580.54999999999995,0,{"$f":"O6+P6","v":580.54999999999995},{"$f":"I6*0.15","v":0},{"$f":"J6*0.15","v":0},{"$f":"R6+S6","v":0},{"$f":"Q6-T6","v":580.54999999999995}]
[{"$f":"'MDM VI to X'!B14","v":"2010-10-02"},{"$f":"A7","v":"2010-10-02"},{"$f":"DATA!$E$9","v":380},147,{"$f":"C7+D7","v":527},51,22,{"$f":"G7+F7","v":73},144,100,{"$f":"I7+J7","v":244},144,100,{"$f":"L7+M7","v":244},580.54999999999995,0,{"$f":"O7+P7","v":580.54999999999995},{"$f":"I7*0.15","v":21.599999999999998},{"$f":"J7*0.15","v":15},{"$f":"R7+S7","v":36.599999999999994},{"$f":"Q7-T7","v":543.94999999999993}]
[{"$f":"'MDM VI to X'!B15","v":"2010-10-03"},"2010-10-03",230,147,377,51,22,73,152,110,262,152,110,262,543.94999999999993,0,543.94999999999993,22.8,16.5,39.299999999999997,504.64999999999992]
[{"$f":"'MDM VI to X'!B16","v":"2010-10-04"},"2010-10-04",230,147,377,51,22,{"$f":"G9+F9","v":73},153,111,264,153,111,264,504.64999999999992,0,504.64999999999992,22.95,16.649999999999999,39.599999999999994,465.04999999999995]
[{"$f":"'MDM VI to X'!B17","v":"2010-10-05"},"2010-10-05",230,147,377,51,22,73,151,114,265,151,114,265,465.04999999999995,500,965.05,22.65,17.099999999999998,39.75,925.3]
[{"$f":"'MDM VI to X'!B18","v":"2010-10-06"},"2010-10-06",230,147,377,51,22,73,154,106,260,154,106,260,925.3,0,925.3,23.099999999999998,15.899999999999999,39,886.3]
[{"$f":"'MDM VI to X'!B19","v":"2010-10-07"},"2010-10-07",230,147,377,51,22,73,151,103,254,151,103,254,886.3,0,886.3,22.65,15.45,38.099999999999994,848.19999999999993]
[{"$f":"'MDM VI to X'!B20","v":"2010-10-08"},"2010-10-08",null,null,null,null,null,null,null,null,null,null,null,null,848.19999999999993,0,848.19999999999993,0,0,0,848.19999999999993]
[{"$f":"'MDM VI to X'!B21","v":"2010-10-09"},"2010-10-09",230,147,377,51,22,73,153,105,258,153,105,{"$f":"L14+M14","v":258},848.19999999999993,0,848.19999999999993,22.95,15.75,38.700000000000003,809.49999999999989]
[{"$f":"'MDM VI to X'!B22","v":"2010-10-10"},"2010-10-10",230,147,377,51,22,{"$f":"G15+F15","v":73},151,101,252,151,101,252,809.49999999999989,0,809.49999999999989,22.65,15.149999999999999,37.799999999999997,771.69999999999993]
[{"$f":"'MDM VI to X'!B23","v":"2010-10-11"},"2010-10-11",230,147,377,51,22,73,154,103,257,154,103,257,771.69999999999993,0,771.69999999999993,23.099999999999998,15.45,38.549999999999997,733.15]
[{"$f":"'MDM VI to X'!B24","v":"2010-10-12"},"2010-10-12",230,147,377,51,22,73,155,105,260,155,105,260,733.15,0,733.15,23.25,15.75,39,694.15]
[{"$f":"'MDM VI to X'!B25","v":"2010-10-13"},"2010-10-13",230,147,377,51,22,73,154,100,254,154,100,254,694.15,0,694.15,23.099999999999998,15,38.099999999999994,656.05]
[{"$f":"'MDM VI to X'!B26","v":"2010-10-14"},"2010-10-14",null,null,null,null,null,null,null,null,null,null,null,null,656.05,0,656.05,0,0,0,656.05]
[{"$f":"'MDM VI to X'!B27","v":"2010-10-15"},"2010-10-15",null,null,null,null,null,null,null,null,null,null,null,null,656.05,0,656.05,0,0,0,656.05]
[{"$f":"'MDM VI to X'!B28","v":"2010-10-16"},"2010-10-16",{"$f":"171+60","v":231},149,380,51,22,73,150,109,259,150,109,{"$f":"L21+M21","v":259},656.05,0,656.05,22.5,16.349999999999998,38.849999999999994,617.19999999999993]
[{"$f":"'MDM VI to X'!B29","v":"2010-10-17"},"2010-10-17",{"$f":"171+60","v":231},149,380,51,22,73,155,106,261,155,106,261,617.19999999999993,0,617.19999999999993,23.25,15.899999999999999,39.15,578.04999999999995]
[{"$f":"'MDM VI to X'!B30","v":"2010-10-18"},"2010-10-18",231,149,380,51,22,73,152,102,254,152,102,254,578.04999999999995,0,578.04999999999995,22.8,15.299999999999999,38.1,539.94999999999993]
[{"$f":"'MDM VI to X'!B31","v":"2010-10-19"},"2010-10-19",231,149,380,51,22,73,149,101,250,149,101,250,539.94999999999993,0,539.94999999999993,22.349999999999998,15.149999999999999,37.5,502.44999999999993]
[{"$f":"'MDM VI to X'!B32","v":"2010-10-20"},"2010-10-20",null,null,null,null,null,null,null,null,null,null,null,null,502.44999999999993,0,502.44999999999993,0,0,0,502.44999999999993]
[{"$f":"'MDM VI to X'!B33","v":"2010-10-21"},"2010-10-21",231,149,380,51,22,73,149,103,252,149,103,{"$f":"L26+M26","v":252},502.44999999999993,0,502.44999999999993,22.349999999999998,15.45,37.799999999999997,464.64999999999992]
[{"$f":"'MDM VI to X'!B34","v":"2010-10-22"},"2010-10-22",null,null,null,null,null,null,null,null,null,null,null,null,464.64999999999992,0,464.64999999999992,0,0,0,464.64999999999992]
[{"$f":"'MDM VI to X'!B35","v":"2010-10-23"},"2010-10-23",231,149,380,51,22,73,151,101,252,151,101,{"$f":"L28+M28","v":252},464.64999999999992,0,464.64999999999992,22.65,15.149999999999999,37.799999999999997,426.84999999999991]
[{"$f":"'MDM VI to X'!B36","v":"2010-10-24"},"2010-10-24",null,null,null,null,null,null,null,null,null,null,null,null,426.84999999999991,0,426.84999999999991,0,0,0,426.84999999999991]
[{"$f":"'MDM VI to X'!B37","v":"2010-10-25"},"2010-10-25",231,149,380,51,22,73,147,96,243,147,96,{"$f":"L30+M30","v":243},426.84999999999991,0,426.84999999999991,22.05,14.399999999999999,36.450000000000003,390.39999999999992]
[{"$f":"'MDM VI to X'!B38","v":"2010-10-26"},"2010-10-26",231,149,380,51,22,73,167,130,297,167,130,297,390.39999999999992,0,390.39999999999992,25.05,19.5,44.55,345.84999999999991]
[{"$f":"'MDM VI to X'!B39","v":"2010-10-27"},"2010-10-27",231,149,380,51,22,73,168,131,299,168,131,299,345.84999999999991,0,345.84999999999991,25.2,19.649999999999999,44.849999999999994,300.99999999999989]
[{"$f":"'MDM VI to X'!B40","v":"2010-10-28"},"2010-10-28",231,149,380,51,22,73,168,130,298,168,130,298,300.99999999999989,0,300.99999999999989,25.2,19.5,44.7,256.2999999999999]
[{"$f":"'MDM VI to X'!B41","v":"2010-10-29"},"2010-10-29",null,null,null,null,null,null,null,null,null,null,null,null,256.2999999999999,0,256.2999999999999,0,0,0,256.2999999999999]
[{"$f":"'MDM VI to X'!B42","v":"2010-10-30"},"2010-10-30",231,149,380,51,22,73,164,126,290,164,126,{"$f":"L35+M35","v":290},256.2999999999999,0,256.2999999999999,24.599999999999998,18.899999999999999,43.5,212.7999999999999]
[{"$f":"'MDM VI to X'!B43","v":"2010-10-31"},"2010-10-31",231,149,380,51,22,73,160,124,284,160,124,284,212.7999999999999,0,212.7999999999999,24,18.599999999999998,42.599999999999994,170.1999999999999]
[{"$f":"'[1]Register VI to VIII & IX To X'!A34","v":"Total"},null,{"$f":"SUM(C6:C36)","v":5832},{"$f":"SUM(D6:D36)","v":3405},8857,1173,506,1679,3552,2517,6069,3552,2517,6069,17445.149999999998,500,17945.149999999998,532.79999999999995,377.54999999999995,910.35,17034.8,0,0,0,0,0,0,0,0]